--TRG_OLG_B_IU_DAT
--TRG_OLG_B_I_PK
--
CREATE OR REPLACE TRIGGER TRG_OLG_B_I_PK
BEFORE INSERT
ON OMSLOG
FOR EACH ROW
BEGIN
  SELECT OMSLOG_OLG_ID_SEQ.NEXTVAL
  INTO :NEW.OLG_ID
  FROM DUAL;
END;
/



CREATE OR REPLACE TRIGGER TRG_OLG_B_IU_DAT
BEFORE INSERT OR UPDATE
ON OMSLOG
FOR EACH ROW
BEGIN
   IF INSERTING THEN
      :NEW.OLG_LOGDATE:= SYSDATE;
   END IF;
END;
-- ************* END OMSLOG ***********
/




